How can I write an Oracle SQL join query to get all COMP_DESC for a specific ITEM_CODE

How to Write0:01:22

How to Write an Oracle SQL Join Query to Get All COMP_DESC for a Specific ITEM_CODE